package com.zed.code.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderDOExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderDOExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserId is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserId is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Integer value) {
            addCriterion("UserId =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Integer value) {
            addCriterion("UserId <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Integer value) {
            addCriterion("UserId >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("UserId >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Integer value) {
            addCriterion("UserId <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Integer value) {
            addCriterion("UserId <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Integer> values) {
            addCriterion("UserId in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Integer> values) {
            addCriterion("UserId not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Integer value1, Integer value2) {
            addCriterion("UserId between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Integer value1, Integer value2) {
            addCriterion("UserId not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andStationidIsNull() {
            addCriterion("StationId is null");
            return (Criteria) this;
        }

        public Criteria andStationidIsNotNull() {
            addCriterion("StationId is not null");
            return (Criteria) this;
        }

        public Criteria andStationidEqualTo(Integer value) {
            addCriterion("StationId =", value, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationidNotEqualTo(Integer value) {
            addCriterion("StationId <>", value, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationidGreaterThan(Integer value) {
            addCriterion("StationId >", value, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationidGreaterThanOrEqualTo(Integer value) {
            addCriterion("StationId >=", value, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationidLessThan(Integer value) {
            addCriterion("StationId <", value, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationidLessThanOrEqualTo(Integer value) {
            addCriterion("StationId <=", value, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationidIn(List<Integer> values) {
            addCriterion("StationId in", values, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationidNotIn(List<Integer> values) {
            addCriterion("StationId not in", values, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationidBetween(Integer value1, Integer value2) {
            addCriterion("StationId between", value1, value2, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationidNotBetween(Integer value1, Integer value2) {
            addCriterion("StationId not between", value1, value2, "stationid");
            return (Criteria) this;
        }

        public Criteria andStationnoIsNull() {
            addCriterion("StationNo is null");
            return (Criteria) this;
        }

        public Criteria andStationnoIsNotNull() {
            addCriterion("StationNo is not null");
            return (Criteria) this;
        }

        public Criteria andStationnoEqualTo(String value) {
            addCriterion("StationNo =", value, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoNotEqualTo(String value) {
            addCriterion("StationNo <>", value, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoGreaterThan(String value) {
            addCriterion("StationNo >", value, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoGreaterThanOrEqualTo(String value) {
            addCriterion("StationNo >=", value, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoLessThan(String value) {
            addCriterion("StationNo <", value, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoLessThanOrEqualTo(String value) {
            addCriterion("StationNo <=", value, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoLike(String value) {
            addCriterion("StationNo like", value, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoNotLike(String value) {
            addCriterion("StationNo not like", value, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoIn(List<String> values) {
            addCriterion("StationNo in", values, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoNotIn(List<String> values) {
            addCriterion("StationNo not in", values, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoBetween(String value1, String value2) {
            addCriterion("StationNo between", value1, value2, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnoNotBetween(String value1, String value2) {
            addCriterion("StationNo not between", value1, value2, "stationno");
            return (Criteria) this;
        }

        public Criteria andStationnameIsNull() {
            addCriterion("StationName is null");
            return (Criteria) this;
        }

        public Criteria andStationnameIsNotNull() {
            addCriterion("StationName is not null");
            return (Criteria) this;
        }

        public Criteria andStationnameEqualTo(String value) {
            addCriterion("StationName =", value, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameNotEqualTo(String value) {
            addCriterion("StationName <>", value, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameGreaterThan(String value) {
            addCriterion("StationName >", value, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameGreaterThanOrEqualTo(String value) {
            addCriterion("StationName >=", value, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameLessThan(String value) {
            addCriterion("StationName <", value, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameLessThanOrEqualTo(String value) {
            addCriterion("StationName <=", value, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameLike(String value) {
            addCriterion("StationName like", value, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameNotLike(String value) {
            addCriterion("StationName not like", value, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameIn(List<String> values) {
            addCriterion("StationName in", values, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameNotIn(List<String> values) {
            addCriterion("StationName not in", values, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameBetween(String value1, String value2) {
            addCriterion("StationName between", value1, value2, "stationname");
            return (Criteria) this;
        }

        public Criteria andStationnameNotBetween(String value1, String value2) {
            addCriterion("StationName not between", value1, value2, "stationname");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNull() {
            addCriterion("OrderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNotNull() {
            addCriterion("OrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernoEqualTo(String value) {
            addCriterion("OrderNo =", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotEqualTo(String value) {
            addCriterion("OrderNo <>", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThan(String value) {
            addCriterion("OrderNo >", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
            addCriterion("OrderNo >=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThan(String value) {
            addCriterion("OrderNo <", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThanOrEqualTo(String value) {
            addCriterion("OrderNo <=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLike(String value) {
            addCriterion("OrderNo like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotLike(String value) {
            addCriterion("OrderNo not like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIn(List<String> values) {
            addCriterion("OrderNo in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotIn(List<String> values) {
            addCriterion("OrderNo not in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoBetween(String value1, String value2) {
            addCriterion("OrderNo between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotBetween(String value1, String value2) {
            addCriterion("OrderNo not between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andDeviceidIsNull() {
            addCriterion("DeviceId is null");
            return (Criteria) this;
        }

        public Criteria andDeviceidIsNotNull() {
            addCriterion("DeviceId is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceidEqualTo(String value) {
            addCriterion("DeviceId =", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidNotEqualTo(String value) {
            addCriterion("DeviceId <>", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidGreaterThan(String value) {
            addCriterion("DeviceId >", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidGreaterThanOrEqualTo(String value) {
            addCriterion("DeviceId >=", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidLessThan(String value) {
            addCriterion("DeviceId <", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidLessThanOrEqualTo(String value) {
            addCriterion("DeviceId <=", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidLike(String value) {
            addCriterion("DeviceId like", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidNotLike(String value) {
            addCriterion("DeviceId not like", value, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidIn(List<String> values) {
            addCriterion("DeviceId in", values, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidNotIn(List<String> values) {
            addCriterion("DeviceId not in", values, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidBetween(String value1, String value2) {
            addCriterion("DeviceId between", value1, value2, "deviceid");
            return (Criteria) this;
        }

        public Criteria andDeviceidNotBetween(String value1, String value2) {
            addCriterion("DeviceId not between", value1, value2, "deviceid");
            return (Criteria) this;
        }

        public Criteria andInnerordernoIsNull() {
            addCriterion("InnerOrderNo is null");
            return (Criteria) this;
        }

        public Criteria andInnerordernoIsNotNull() {
            addCriterion("InnerOrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andInnerordernoEqualTo(String value) {
            addCriterion("InnerOrderNo =", value, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoNotEqualTo(String value) {
            addCriterion("InnerOrderNo <>", value, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoGreaterThan(String value) {
            addCriterion("InnerOrderNo >", value, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoGreaterThanOrEqualTo(String value) {
            addCriterion("InnerOrderNo >=", value, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoLessThan(String value) {
            addCriterion("InnerOrderNo <", value, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoLessThanOrEqualTo(String value) {
            addCriterion("InnerOrderNo <=", value, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoLike(String value) {
            addCriterion("InnerOrderNo like", value, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoNotLike(String value) {
            addCriterion("InnerOrderNo not like", value, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoIn(List<String> values) {
            addCriterion("InnerOrderNo in", values, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoNotIn(List<String> values) {
            addCriterion("InnerOrderNo not in", values, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoBetween(String value1, String value2) {
            addCriterion("InnerOrderNo between", value1, value2, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andInnerordernoNotBetween(String value1, String value2) {
            addCriterion("InnerOrderNo not between", value1, value2, "innerorderno");
            return (Criteria) this;
        }

        public Criteria andPaymethodIsNull() {
            addCriterion("PayMethod is null");
            return (Criteria) this;
        }

        public Criteria andPaymethodIsNotNull() {
            addCriterion("PayMethod is not null");
            return (Criteria) this;
        }

        public Criteria andPaymethodEqualTo(Integer value) {
            addCriterion("PayMethod =", value, "paymethod");
            return (Criteria) this;
        }

        public Criteria andPaymethodNotEqualTo(Integer value) {
            addCriterion("PayMethod <>", value, "paymethod");
            return (Criteria) this;
        }

        public Criteria andPaymethodGreaterThan(Integer value) {
            addCriterion("PayMethod >", value, "paymethod");
            return (Criteria) this;
        }

        public Criteria andPaymethodGreaterThanOrEqualTo(Integer value) {
            addCriterion("PayMethod >=", value, "paymethod");
            return (Criteria) this;
        }

        public Criteria andPaymethodLessThan(Integer value) {
            addCriterion("PayMethod <", value, "paymethod");
            return (Criteria) this;
        }

        public Criteria andPaymethodLessThanOrEqualTo(Integer value) {
            addCriterion("PayMethod <=", value, "paymethod");
            return (Criteria) this;
        }

        public Criteria andPaymethodIn(List<Integer> values) {
            addCriterion("PayMethod in", values, "paymethod");
            return (Criteria) this;
        }

        public Criteria andPaymethodNotIn(List<Integer> values) {
            addCriterion("PayMethod not in", values, "paymethod");
            return (Criteria) this;
        }

        public Criteria andPaymethodBetween(Integer value1, Integer value2) {
            addCriterion("PayMethod between", value1, value2, "paymethod");
            return (Criteria) this;
        }

        public Criteria andPaymethodNotBetween(Integer value1, Integer value2) {
            addCriterion("PayMethod not between", value1, value2, "paymethod");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIsNull() {
            addCriterion("OrderStatus is null");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIsNotNull() {
            addCriterion("OrderStatus is not null");
            return (Criteria) this;
        }

        public Criteria andOrderstatusEqualTo(Integer value) {
            addCriterion("OrderStatus =", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotEqualTo(Integer value) {
            addCriterion("OrderStatus <>", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusGreaterThan(Integer value) {
            addCriterion("OrderStatus >", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("OrderStatus >=", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLessThan(Integer value) {
            addCriterion("OrderStatus <", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLessThanOrEqualTo(Integer value) {
            addCriterion("OrderStatus <=", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIn(List<Integer> values) {
            addCriterion("OrderStatus in", values, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotIn(List<Integer> values) {
            addCriterion("OrderStatus not in", values, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusBetween(Integer value1, Integer value2) {
            addCriterion("OrderStatus between", value1, value2, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("OrderStatus not between", value1, value2, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andPayaccountIsNull() {
            addCriterion("PayAccount is null");
            return (Criteria) this;
        }

        public Criteria andPayaccountIsNotNull() {
            addCriterion("PayAccount is not null");
            return (Criteria) this;
        }

        public Criteria andPayaccountEqualTo(String value) {
            addCriterion("PayAccount =", value, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountNotEqualTo(String value) {
            addCriterion("PayAccount <>", value, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountGreaterThan(String value) {
            addCriterion("PayAccount >", value, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountGreaterThanOrEqualTo(String value) {
            addCriterion("PayAccount >=", value, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountLessThan(String value) {
            addCriterion("PayAccount <", value, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountLessThanOrEqualTo(String value) {
            addCriterion("PayAccount <=", value, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountLike(String value) {
            addCriterion("PayAccount like", value, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountNotLike(String value) {
            addCriterion("PayAccount not like", value, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountIn(List<String> values) {
            addCriterion("PayAccount in", values, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountNotIn(List<String> values) {
            addCriterion("PayAccount not in", values, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountBetween(String value1, String value2) {
            addCriterion("PayAccount between", value1, value2, "payaccount");
            return (Criteria) this;
        }

        public Criteria andPayaccountNotBetween(String value1, String value2) {
            addCriterion("PayAccount not between", value1, value2, "payaccount");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("Amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("Amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(BigDecimal value) {
            addCriterion("Amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(BigDecimal value) {
            addCriterion("Amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(BigDecimal value) {
            addCriterion("Amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(BigDecimal value) {
            addCriterion("Amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<BigDecimal> values) {
            addCriterion("Amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<BigDecimal> values) {
            addCriterion("Amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNull() {
            addCriterion("CardNo is null");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNotNull() {
            addCriterion("CardNo is not null");
            return (Criteria) this;
        }

        public Criteria andCardnoEqualTo(String value) {
            addCriterion("CardNo =", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotEqualTo(String value) {
            addCriterion("CardNo <>", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThan(String value) {
            addCriterion("CardNo >", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThanOrEqualTo(String value) {
            addCriterion("CardNo >=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThan(String value) {
            addCriterion("CardNo <", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThanOrEqualTo(String value) {
            addCriterion("CardNo <=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLike(String value) {
            addCriterion("CardNo like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotLike(String value) {
            addCriterion("CardNo not like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoIn(List<String> values) {
            addCriterion("CardNo in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotIn(List<String> values) {
            addCriterion("CardNo not in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoBetween(String value1, String value2) {
            addCriterion("CardNo between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotBetween(String value1, String value2) {
            addCriterion("CardNo not between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNull() {
            addCriterion("Quantity is null");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNotNull() {
            addCriterion("Quantity is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityEqualTo(BigDecimal value) {
            addCriterion("Quantity =", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotEqualTo(BigDecimal value) {
            addCriterion("Quantity <>", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThan(BigDecimal value) {
            addCriterion("Quantity >", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Quantity >=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThan(BigDecimal value) {
            addCriterion("Quantity <", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Quantity <=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityIn(List<BigDecimal> values) {
            addCriterion("Quantity in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotIn(List<BigDecimal> values) {
            addCriterion("Quantity not in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Quantity between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Quantity not between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andPaiddateIsNull() {
            addCriterion("PaidDate is null");
            return (Criteria) this;
        }

        public Criteria andPaiddateIsNotNull() {
            addCriterion("PaidDate is not null");
            return (Criteria) this;
        }

        public Criteria andPaiddateEqualTo(Date value) {
            addCriterion("PaidDate =", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateNotEqualTo(Date value) {
            addCriterion("PaidDate <>", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateGreaterThan(Date value) {
            addCriterion("PaidDate >", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateGreaterThanOrEqualTo(Date value) {
            addCriterion("PaidDate >=", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateLessThan(Date value) {
            addCriterion("PaidDate <", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateLessThanOrEqualTo(Date value) {
            addCriterion("PaidDate <=", value, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateIn(List<Date> values) {
            addCriterion("PaidDate in", values, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateNotIn(List<Date> values) {
            addCriterion("PaidDate not in", values, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateBetween(Date value1, Date value2) {
            addCriterion("PaidDate between", value1, value2, "paiddate");
            return (Criteria) this;
        }

        public Criteria andPaiddateNotBetween(Date value1, Date value2) {
            addCriterion("PaidDate not between", value1, value2, "paiddate");
            return (Criteria) this;
        }

        public Criteria andCreatedateIsNull() {
            addCriterion("CreateDate is null");
            return (Criteria) this;
        }

        public Criteria andCreatedateIsNotNull() {
            addCriterion("CreateDate is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedateEqualTo(Date value) {
            addCriterion("CreateDate =", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateNotEqualTo(Date value) {
            addCriterion("CreateDate <>", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateGreaterThan(Date value) {
            addCriterion("CreateDate >", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("CreateDate >=", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateLessThan(Date value) {
            addCriterion("CreateDate <", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateLessThanOrEqualTo(Date value) {
            addCriterion("CreateDate <=", value, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateIn(List<Date> values) {
            addCriterion("CreateDate in", values, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateNotIn(List<Date> values) {
            addCriterion("CreateDate not in", values, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateBetween(Date value1, Date value2) {
            addCriterion("CreateDate between", value1, value2, "createdate");
            return (Criteria) this;
        }

        public Criteria andCreatedateNotBetween(Date value1, Date value2) {
            addCriterion("CreateDate not between", value1, value2, "createdate");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("`Name` is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("`Name` is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("`Name` =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("`Name` <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("`Name` >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("`Name` >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("`Name` <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("`Name` <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("`Name` like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("`Name` not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("`Name` in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("`Name` not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("`Name` between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("`Name` not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("Mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("Mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("Mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("Mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("Mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("Mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("Mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("Mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("Mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("Mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("Mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("Mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("Mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("Mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andStartdateIsNull() {
            addCriterion("StartDate is null");
            return (Criteria) this;
        }

        public Criteria andStartdateIsNotNull() {
            addCriterion("StartDate is not null");
            return (Criteria) this;
        }

        public Criteria andStartdateEqualTo(Date value) {
            addCriterion("StartDate =", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateNotEqualTo(Date value) {
            addCriterion("StartDate <>", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateGreaterThan(Date value) {
            addCriterion("StartDate >", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateGreaterThanOrEqualTo(Date value) {
            addCriterion("StartDate >=", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateLessThan(Date value) {
            addCriterion("StartDate <", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateLessThanOrEqualTo(Date value) {
            addCriterion("StartDate <=", value, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateIn(List<Date> values) {
            addCriterion("StartDate in", values, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateNotIn(List<Date> values) {
            addCriterion("StartDate not in", values, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateBetween(Date value1, Date value2) {
            addCriterion("StartDate between", value1, value2, "startdate");
            return (Criteria) this;
        }

        public Criteria andStartdateNotBetween(Date value1, Date value2) {
            addCriterion("StartDate not between", value1, value2, "startdate");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNull() {
            addCriterion("EndDate is null");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNotNull() {
            addCriterion("EndDate is not null");
            return (Criteria) this;
        }

        public Criteria andEnddateEqualTo(Date value) {
            addCriterion("EndDate =", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotEqualTo(Date value) {
            addCriterion("EndDate <>", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThan(Date value) {
            addCriterion("EndDate >", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThanOrEqualTo(Date value) {
            addCriterion("EndDate >=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThan(Date value) {
            addCriterion("EndDate <", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThanOrEqualTo(Date value) {
            addCriterion("EndDate <=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateIn(List<Date> values) {
            addCriterion("EndDate in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotIn(List<Date> values) {
            addCriterion("EndDate not in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateBetween(Date value1, Date value2) {
            addCriterion("EndDate between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotBetween(Date value1, Date value2) {
            addCriterion("EndDate not between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andSessionidIsNull() {
            addCriterion("SessionId is null");
            return (Criteria) this;
        }

        public Criteria andSessionidIsNotNull() {
            addCriterion("SessionId is not null");
            return (Criteria) this;
        }

        public Criteria andSessionidEqualTo(String value) {
            addCriterion("SessionId =", value, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidNotEqualTo(String value) {
            addCriterion("SessionId <>", value, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidGreaterThan(String value) {
            addCriterion("SessionId >", value, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidGreaterThanOrEqualTo(String value) {
            addCriterion("SessionId >=", value, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidLessThan(String value) {
            addCriterion("SessionId <", value, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidLessThanOrEqualTo(String value) {
            addCriterion("SessionId <=", value, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidLike(String value) {
            addCriterion("SessionId like", value, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidNotLike(String value) {
            addCriterion("SessionId not like", value, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidIn(List<String> values) {
            addCriterion("SessionId in", values, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidNotIn(List<String> values) {
            addCriterion("SessionId not in", values, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidBetween(String value1, String value2) {
            addCriterion("SessionId between", value1, value2, "sessionid");
            return (Criteria) this;
        }

        public Criteria andSessionidNotBetween(String value1, String value2) {
            addCriterion("SessionId not between", value1, value2, "sessionid");
            return (Criteria) this;
        }

        public Criteria andBalanceIsNull() {
            addCriterion("Balance is null");
            return (Criteria) this;
        }

        public Criteria andBalanceIsNotNull() {
            addCriterion("Balance is not null");
            return (Criteria) this;
        }

        public Criteria andBalanceEqualTo(BigDecimal value) {
            addCriterion("Balance =", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceNotEqualTo(BigDecimal value) {
            addCriterion("Balance <>", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceGreaterThan(BigDecimal value) {
            addCriterion("Balance >", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Balance >=", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceLessThan(BigDecimal value) {
            addCriterion("Balance <", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Balance <=", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceIn(List<BigDecimal> values) {
            addCriterion("Balance in", values, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceNotIn(List<BigDecimal> values) {
            addCriterion("Balance not in", values, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Balance between", value1, value2, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Balance not between", value1, value2, "balance");
            return (Criteria) this;
        }

        public Criteria andChargestatusIsNull() {
            addCriterion("ChargeStatus is null");
            return (Criteria) this;
        }

        public Criteria andChargestatusIsNotNull() {
            addCriterion("ChargeStatus is not null");
            return (Criteria) this;
        }

        public Criteria andChargestatusEqualTo(Integer value) {
            addCriterion("ChargeStatus =", value, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargestatusNotEqualTo(Integer value) {
            addCriterion("ChargeStatus <>", value, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargestatusGreaterThan(Integer value) {
            addCriterion("ChargeStatus >", value, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargestatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("ChargeStatus >=", value, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargestatusLessThan(Integer value) {
            addCriterion("ChargeStatus <", value, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargestatusLessThanOrEqualTo(Integer value) {
            addCriterion("ChargeStatus <=", value, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargestatusIn(List<Integer> values) {
            addCriterion("ChargeStatus in", values, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargestatusNotIn(List<Integer> values) {
            addCriterion("ChargeStatus not in", values, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargestatusBetween(Integer value1, Integer value2) {
            addCriterion("ChargeStatus between", value1, value2, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargestatusNotBetween(Integer value1, Integer value2) {
            addCriterion("ChargeStatus not between", value1, value2, "chargestatus");
            return (Criteria) this;
        }

        public Criteria andChargemodeIsNull() {
            addCriterion("ChargeMode is null");
            return (Criteria) this;
        }

        public Criteria andChargemodeIsNotNull() {
            addCriterion("ChargeMode is not null");
            return (Criteria) this;
        }

        public Criteria andChargemodeEqualTo(Integer value) {
            addCriterion("ChargeMode =", value, "chargemode");
            return (Criteria) this;
        }

        public Criteria andChargemodeNotEqualTo(Integer value) {
            addCriterion("ChargeMode <>", value, "chargemode");
            return (Criteria) this;
        }

        public Criteria andChargemodeGreaterThan(Integer value) {
            addCriterion("ChargeMode >", value, "chargemode");
            return (Criteria) this;
        }

        public Criteria andChargemodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ChargeMode >=", value, "chargemode");
            return (Criteria) this;
        }

        public Criteria andChargemodeLessThan(Integer value) {
            addCriterion("ChargeMode <", value, "chargemode");
            return (Criteria) this;
        }

        public Criteria andChargemodeLessThanOrEqualTo(Integer value) {
            addCriterion("ChargeMode <=", value, "chargemode");
            return (Criteria) this;
        }

        public Criteria andChargemodeIn(List<Integer> values) {
            addCriterion("ChargeMode in", values, "chargemode");
            return (Criteria) this;
        }

        public Criteria andChargemodeNotIn(List<Integer> values) {
            addCriterion("ChargeMode not in", values, "chargemode");
            return (Criteria) this;
        }

        public Criteria andChargemodeBetween(Integer value1, Integer value2) {
            addCriterion("ChargeMode between", value1, value2, "chargemode");
            return (Criteria) this;
        }

        public Criteria andChargemodeNotBetween(Integer value1, Integer value2) {
            addCriterion("ChargeMode not between", value1, value2, "chargemode");
            return (Criteria) this;
        }

        public Criteria andModevalueIsNull() {
            addCriterion("ModeValue is null");
            return (Criteria) this;
        }

        public Criteria andModevalueIsNotNull() {
            addCriterion("ModeValue is not null");
            return (Criteria) this;
        }

        public Criteria andModevalueEqualTo(BigDecimal value) {
            addCriterion("ModeValue =", value, "modevalue");
            return (Criteria) this;
        }

        public Criteria andModevalueNotEqualTo(BigDecimal value) {
            addCriterion("ModeValue <>", value, "modevalue");
            return (Criteria) this;
        }

        public Criteria andModevalueGreaterThan(BigDecimal value) {
            addCriterion("ModeValue >", value, "modevalue");
            return (Criteria) this;
        }

        public Criteria andModevalueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ModeValue >=", value, "modevalue");
            return (Criteria) this;
        }

        public Criteria andModevalueLessThan(BigDecimal value) {
            addCriterion("ModeValue <", value, "modevalue");
            return (Criteria) this;
        }

        public Criteria andModevalueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ModeValue <=", value, "modevalue");
            return (Criteria) this;
        }

        public Criteria andModevalueIn(List<BigDecimal> values) {
            addCriterion("ModeValue in", values, "modevalue");
            return (Criteria) this;
        }

        public Criteria andModevalueNotIn(List<BigDecimal> values) {
            addCriterion("ModeValue not in", values, "modevalue");
            return (Criteria) this;
        }

        public Criteria andModevalueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ModeValue between", value1, value2, "modevalue");
            return (Criteria) this;
        }

        public Criteria andModevalueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ModeValue not between", value1, value2, "modevalue");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeIsNull() {
            addCriterion("UserStartTime is null");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeIsNotNull() {
            addCriterion("UserStartTime is not null");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeEqualTo(Date value) {
            addCriterion("UserStartTime =", value, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeNotEqualTo(Date value) {
            addCriterion("UserStartTime <>", value, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeGreaterThan(Date value) {
            addCriterion("UserStartTime >", value, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UserStartTime >=", value, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeLessThan(Date value) {
            addCriterion("UserStartTime <", value, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeLessThanOrEqualTo(Date value) {
            addCriterion("UserStartTime <=", value, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeIn(List<Date> values) {
            addCriterion("UserStartTime in", values, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeNotIn(List<Date> values) {
            addCriterion("UserStartTime not in", values, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeBetween(Date value1, Date value2) {
            addCriterion("UserStartTime between", value1, value2, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andUserstarttimeNotBetween(Date value1, Date value2) {
            addCriterion("UserStartTime not between", value1, value2, "userstarttime");
            return (Criteria) this;
        }

        public Criteria andDeviceportIsNull() {
            addCriterion("DevicePort is null");
            return (Criteria) this;
        }

        public Criteria andDeviceportIsNotNull() {
            addCriterion("DevicePort is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceportEqualTo(String value) {
            addCriterion("DevicePort =", value, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportNotEqualTo(String value) {
            addCriterion("DevicePort <>", value, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportGreaterThan(String value) {
            addCriterion("DevicePort >", value, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportGreaterThanOrEqualTo(String value) {
            addCriterion("DevicePort >=", value, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportLessThan(String value) {
            addCriterion("DevicePort <", value, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportLessThanOrEqualTo(String value) {
            addCriterion("DevicePort <=", value, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportLike(String value) {
            addCriterion("DevicePort like", value, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportNotLike(String value) {
            addCriterion("DevicePort not like", value, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportIn(List<String> values) {
            addCriterion("DevicePort in", values, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportNotIn(List<String> values) {
            addCriterion("DevicePort not in", values, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportBetween(String value1, String value2) {
            addCriterion("DevicePort between", value1, value2, "deviceport");
            return (Criteria) this;
        }

        public Criteria andDeviceportNotBetween(String value1, String value2) {
            addCriterion("DevicePort not between", value1, value2, "deviceport");
            return (Criteria) this;
        }

        public Criteria andOpenidIsNull() {
            addCriterion("OpenId is null");
            return (Criteria) this;
        }

        public Criteria andOpenidIsNotNull() {
            addCriterion("OpenId is not null");
            return (Criteria) this;
        }

        public Criteria andOpenidEqualTo(String value) {
            addCriterion("OpenId =", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidNotEqualTo(String value) {
            addCriterion("OpenId <>", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidGreaterThan(String value) {
            addCriterion("OpenId >", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidGreaterThanOrEqualTo(String value) {
            addCriterion("OpenId >=", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidLessThan(String value) {
            addCriterion("OpenId <", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidLessThanOrEqualTo(String value) {
            addCriterion("OpenId <=", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidLike(String value) {
            addCriterion("OpenId like", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidNotLike(String value) {
            addCriterion("OpenId not like", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidIn(List<String> values) {
            addCriterion("OpenId in", values, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidNotIn(List<String> values) {
            addCriterion("OpenId not in", values, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidBetween(String value1, String value2) {
            addCriterion("OpenId between", value1, value2, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidNotBetween(String value1, String value2) {
            addCriterion("OpenId not between", value1, value2, "openid");
            return (Criteria) this;
        }

        public Criteria andWxusernameIsNull() {
            addCriterion("WXUserName is null");
            return (Criteria) this;
        }

        public Criteria andWxusernameIsNotNull() {
            addCriterion("WXUserName is not null");
            return (Criteria) this;
        }

        public Criteria andWxusernameEqualTo(String value) {
            addCriterion("WXUserName =", value, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameNotEqualTo(String value) {
            addCriterion("WXUserName <>", value, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameGreaterThan(String value) {
            addCriterion("WXUserName >", value, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameGreaterThanOrEqualTo(String value) {
            addCriterion("WXUserName >=", value, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameLessThan(String value) {
            addCriterion("WXUserName <", value, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameLessThanOrEqualTo(String value) {
            addCriterion("WXUserName <=", value, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameLike(String value) {
            addCriterion("WXUserName like", value, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameNotLike(String value) {
            addCriterion("WXUserName not like", value, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameIn(List<String> values) {
            addCriterion("WXUserName in", values, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameNotIn(List<String> values) {
            addCriterion("WXUserName not in", values, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameBetween(String value1, String value2) {
            addCriterion("WXUserName between", value1, value2, "wxusername");
            return (Criteria) this;
        }

        public Criteria andWxusernameNotBetween(String value1, String value2) {
            addCriterion("WXUserName not between", value1, value2, "wxusername");
            return (Criteria) this;
        }

        public Criteria andServicefeeIsNull() {
            addCriterion("ServiceFee is null");
            return (Criteria) this;
        }

        public Criteria andServicefeeIsNotNull() {
            addCriterion("ServiceFee is not null");
            return (Criteria) this;
        }

        public Criteria andServicefeeEqualTo(BigDecimal value) {
            addCriterion("ServiceFee =", value, "servicefee");
            return (Criteria) this;
        }

        public Criteria andServicefeeNotEqualTo(BigDecimal value) {
            addCriterion("ServiceFee <>", value, "servicefee");
            return (Criteria) this;
        }

        public Criteria andServicefeeGreaterThan(BigDecimal value) {
            addCriterion("ServiceFee >", value, "servicefee");
            return (Criteria) this;
        }

        public Criteria andServicefeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ServiceFee >=", value, "servicefee");
            return (Criteria) this;
        }

        public Criteria andServicefeeLessThan(BigDecimal value) {
            addCriterion("ServiceFee <", value, "servicefee");
            return (Criteria) this;
        }

        public Criteria andServicefeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ServiceFee <=", value, "servicefee");
            return (Criteria) this;
        }

        public Criteria andServicefeeIn(List<BigDecimal> values) {
            addCriterion("ServiceFee in", values, "servicefee");
            return (Criteria) this;
        }

        public Criteria andServicefeeNotIn(List<BigDecimal> values) {
            addCriterion("ServiceFee not in", values, "servicefee");
            return (Criteria) this;
        }

        public Criteria andServicefeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ServiceFee between", value1, value2, "servicefee");
            return (Criteria) this;
        }

        public Criteria andServicefeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ServiceFee not between", value1, value2, "servicefee");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}